package com.xbao.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.HashMap;

@Mapper
public interface ClsExtraMapper {
    @Select("select sum(case when status=1 then 1 else 0 end) as finishrecord,sum(case when status=0 then 1 else 0 end) as remianrecord,count(1) as totalrecord from cls where id=#{id}")
    public HashMap<String,Integer> finishRecordCount (Long cid);
}
